package com._51cto.healthy.mapper;

import com._51cto.healthy.base.BaseMapper;
import com._51cto.healthy.pojo.SetMeal;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/****
 * @Author:DancingHorse
 * @Description:TSetmealMapper层
 * @Date 2022/4/14 0:12
 *****/
public interface SetMealMapper extends BaseMapper<SetMeal> {
    //获取全部数据
    List<SetMeal> queryPageList(@Param("query") String query);
    //获取检测项id
    List<Integer>  queryItemIds(Integer id);
    //根据套餐删除检测组id
    void deleteGroupIdBysetMeal(@Param("id") Integer id);
    //插入检测组id和套餐
    void insertGroupIdWithsetMeal(@Param("setMealId") Integer setMealId, @Param("groupId") Integer groupId);
    //插入检测组id
    void insertGroupId(@Param("setMealId")Integer setMealId, @Param("groupId")Integer groupId);
    //在数据库中查询最热门的前六个套餐
    List<SetMeal> queryHot(@Param("num") Integer num);

    SetMeal queryInfoByPK(@Param("id") Integer id);


    List<SetMeal> searchSetMeal(@Param("k") String k);
}
